
exports.path = '/vpnGroup/selByGroupNum';
exports.title = '根据id查询';
exports.pool = 'task';

exports.sqltext = `
select a.vpn_group_num from ucr_crm1.tf_b_vpn_group a WHERE a.vpn_group_num=:vpnGroupNum
`;
exports.request = {

};

exports.outConverter = (sqlResult, req) => {
  const result = sqlResult.rows[0];
  if (!result) throw new Error(`查无VPN组号信息 vpnGroupNum:${req.vpnGroupNum}`);
  return result;
};
